/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */

package com.zjdt.epserver.servlet.web.cargo;


import com.zjdt.epserver.db.service4mysql.CargoServiceImpl;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.List;
import java.util.Map;
import javax.servlet.ServletContext;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import org.dusin.web.util.JsonUtil;
import org.springframework.context.ApplicationContext;
import org.springframework.web.context.support.WebApplicationContextUtils;

/**
 *
 * @author dusin
 */
@WebServlet(name = "CargoLoad4BigScreen", urlPatterns = {"/servlet/web/cargo/Load4BigScreen"})
public class Load4BigScreen extends HttpServlet {
    private CargoServiceImpl instance;

    /**
     * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
     * methods.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/json;charset=UTF-8");
        PrintWriter out = response.getWriter();   
        try {           
            ApplicationContext context = WebApplicationContextUtils.getWebApplicationContext(getServletContext());
            instance = (CargoServiceImpl) context.getBean("cargoService");
            HttpSession session = request.getSession();
            String username =(String) session.getAttribute("username");
            ServletContext sc = request.getServletContext();
            String factoryCode = (String)session.getAttribute("factoryCode");
            String companyCode = (String)session.getAttribute("companyCode");
            String dateFrom = null;
            //Integer ID = (Integer)session.getAttribute("ID");  //大概4次ID会为null
            //Integer IDInSc = (Integer)sc.getAttribute(username);
            String dateTo= null;            
            String key = null;
            int page=1;
            int rows=14;
           
            //int total = instance.findCount(companyCode,factoryCode, dateFrom, dateTo, key);
            List<Map<String, Object>> cargos=instance.findAll4BigScreen(null,companyCode,factoryCode,dateFrom,dateTo,key,(page-1)*rows,rows);
            //if(cargos!=null&&cargos.size()>0){    //只获取新数据，当刷新页面时，将无数据显示，所有废弃了该方案
            //    ID = (Integer)cargos.get(0).get("ID");
             //   session.setAttribute("ID", ID);
             //   sc.setAttribute(username, ID);
           // }
            String result = JsonUtil.toDatagrid(cargos);
            //不能根据ArrivalTime进行筛选，因为业务数据可能在手机上保存了一段时间后再上传，这样的话，大屏就可能无法检索出该条数据。可以根据ID进行检索，因为ID是自动增长的。
            //String now = DateUtil.get(new Date(), "yyyy-MM-dd HH:mm:ss");  
            //session.setAttribute("dateFrom", now);
            out.println(result);
        } catch (Exception e) {
            String errResult = JsonUtil.createFailureJsonResponse(null);
            out.println(errResult);
            e.printStackTrace();
        } finally {
            out.close();
        }
    }

    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /**
     * Handles the HTTP <code>GET</code> method.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /**
     * Handles the HTTP <code>POST</code> method.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /**
     * Returns a short description of the servlet.
     *
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>

}
